CREATE TABLE IF NOT EXISTS MIRROR.LOG(
	DATE_LOG   DATE NOT NULL,
	TYPE       VARCHAR NOT NULL,
	ID         INTEGER NOT NULL,
	NAME_TABLE VARCHAR NOT NULL,
	PRIMARY KEY (DATE_LOG, ID)
);

CREATE TABLE IF NOT EXISTS MIRROR.md_account_d(
    data_actual_date     date not null,
    data_actual_end_date date not null,
    account_rk           integer,
    account_number       varchar(20),
    char_type            varchar(1),
    CURRENCY_RK          integer,
    currency_code        varchar(3),
    client_id            integer,
    branch_id            integer,
    open_in_internet     varchar(1),
    primary key (data_actual_date, account_rk)
);